create procedure [dbo].[BAEOrderSuperProductChildProductAttributeUpdate] @OrderSuperProductChildProductID as
int,
    @OrderSuperProductAttributeValueIDNew AS int,
    @OrderSuperProductAttributeValueIDOld AS int
AS
    DELETE FROM OrderSuperProductChildProductAttribute
    WHERE OrderSuperProductChildProductID = @OrderSuperProductChildProductID AND
        OrderSuperProductAttributeValueID = @OrderSuperProductAttributeValueIDOld
    INSERT INTO OrderSuperProductChildProductAttribute
    (    
    OrderSuperProductChildProductID,            
    OrderSuperProductAttributeValueID        
    )
    VALUES
    (    
    @OrderSuperProductChildProductID,            
    @OrderSuperProductAttributeValueIDNew                                                                    
    );

GO